﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_SMS_GetSentHistory]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_SMS_GetSentHistory];
GO
CREATE PROCEDURE [dbo].[sproc_SMS_GetSentHistory]
    
/*

===================================================
功能:    获取100条历史记录
参数:
    @date 日期
    
        
返回值:
    记录集
===================================================

*/
AS

SET NOCOUNT ON


SELECT top 100 * FROM UDS_SMS_MobileMsgSendHistory  ORDER BY SendTime DESC
            
SET NOCOUNT OFF